﻿CREATE TABLE [dbo].[Supplier] (
    [Id]             UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]           NVARCHAR (250)   NOT NULL,
    [Address]        NTEXT            NOT NULL,
    [PrimaryPhone]   NVARCHAR (50)    NOT NULL,
    [SecondaryPhone] NVARCHAR (50)    NULL,
    [PrimaryEmail]   NVARCHAR (250)   NULL,
    [SecondaryEmail] NVARCHAR (250)   NULL,
    [Fax]            NVARCHAR (50)    NULL,
    [WebAddress]     NVARCHAR (250)   NULL,
    [LogoLocation]   NVARCHAR (250)   NULL,
    [CountryId]      UNIQUEIDENTIFIER NOT NULL
);

